SupportUser_ActivityLogs Tables
The leaseCompany_enquiry_serviceUnit_supportUser_activityLogs_latest and leaseCompany_enquiry_serviceUnit_supportUser_activityLogs_changelog tables stores the activities of support console users for of all the enquiries.
🔹 Standard Columns​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
document_name | STRING | YES | Name of the Firestore document |
document_event_id | STRING | YES | Unique ID representing the document event (change ID) |
document_timestamp | TIMESTAMP | YES | Timestamp when the document event occurred |
document_operation | STRING | YES | Type of Firestore operation (e.g., CREATE, UPDATE, DELETE) |
document_id | STRING | YES | ID of the Firestore document |
accountId | STRING | YES | Account identifier related to the document |
serviceUnitId | STRING | YES | Identifier of the service unit |
enquiryId | STRING | YES | Identifier for the enquiry associated with the document |
leaseCompanyId | STRING | YES | Identifier for the lease company related to this record |
lastActivityTimestamp | TIMESTAMP | YES | Timestamp of the last activity performed |
🔸 Array Columns​
Array of STRUCT
activities​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
label | STRING | YES | Description of the activity (e.g., "viewed enquiry 1234") |
timestamp | TIMESTAMP | YES | When the activity occurred |
username | STRING | YES | Username of the person who performed the activity |